UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXcLBQ6R4SenEMElj2nGjpgUuGaHelhsCqVXP1MGUMY='
WHERE
key_id = '8d4bf78887d743b6684128da054420a86c0c27d3e7ff370b7e2364f4b4f2a7d4'
AND (
token = 'BXcLBQ6R4SenEMElj2nGjpgUuGaHelhsCqVXP1MGUMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)