UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NDccl2g0cRBRIwD2K8D+3N/6w06LnpJXPMrY+Jc67TY='
WHERE
key_id = 'ac9047a8045b770732b59141f3eb7cd53049857cea06724ee9b362620cd29fce'
AND (
token = 'NDccl2g0cRBRIwD2K8D+3N/6w06LnpJXPMrY+Jc67TY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)