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