UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ts7B8iJMRezdcxZpmUQ2oGibjdMF0sUn2RI9xipcwW0='
WHERE
key_id = '0694f63bd2d7cef2baa8b328401966aff0b7579ef6cbced2105f4c9a5c7781af'
AND (
token = 'Ts7B8iJMRezdcxZpmUQ2oGibjdMF0sUn2RI9xipcwW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)