UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hSXhUBRa/DPXc+OXU27Hlgxcyso8Z9xJjSbKb9BNkMk='
WHERE
key_id = '765d46e03a5f3a25c7c45ee2a6ffd95db1366973c02f801fbc3c48600f871db3'
AND (
token = 'hSXhUBRa/DPXc+OXU27Hlgxcyso8Z9xJjSbKb9BNkMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)