UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5SQwcEagsqiA5gQrPtWWOPLYlB+l9tbpfyGr2e33fs0='
WHERE
key_id = 'b8a8c94badd5674858f661b83a13257cad028631480503000ec71a3119a0afeb'
AND (
token = '5SQwcEagsqiA5gQrPtWWOPLYlB+l9tbpfyGr2e33fs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)