UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7srvmXtepFFKTD5wfI8z+mhB23I86BRXdqsrHxkEbt8='
WHERE
key_id = '31ef969ca54ae8f670381b39efc44eab52b502c222bd37e83269bcde7ce884e9'
AND (
token = '7srvmXtepFFKTD5wfI8z+mhB23I86BRXdqsrHxkEbt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)