UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n1Cv2SZ3heXvcM0+d2e7SA88Mdv9yXvRyIeAd+ijvgA='
WHERE
key_id = '4efe77f7f4dc04bee4b5db461f6a3db2b1d2388aac5227ec1f9f3bc379f4ae9f'
AND (
token = 'n1Cv2SZ3heXvcM0+d2e7SA88Mdv9yXvRyIeAd+ijvgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)