UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfRpNpMU3zyiMMMsKZGMTD22YxVY9Fdr2JHnvAbfW1Y='
WHERE
key_id = 'acfb34d40e9dce338c1f1ed762e5c3b7ec1c0d0f924521032690649af0f12e59'
AND (
token = 'xfRpNpMU3zyiMMMsKZGMTD22YxVY9Fdr2JHnvAbfW1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)