UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g/1PBnlKCk4Fe0WlPlqmzOo7mevZDdNCqV8U6P0jwMY='
WHERE
key_id = '9d78625eb69fc1b7c99dc87aedeb5e010f26e32e26e05b8163312feb2cbd2839'
AND (
token = 'g/1PBnlKCk4Fe0WlPlqmzOo7mevZDdNCqV8U6P0jwMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)