UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q2KZVnUlgzX0Q7HYp0Ei6lS6IYlhb+bNudnS1MGg6Zk='
WHERE
key_id = '78ed01e9aad2f41a46fbfdf98451193b5f24655b0363a64e384f834ac4453ab2'
AND (
token = 'q2KZVnUlgzX0Q7HYp0Ei6lS6IYlhb+bNudnS1MGg6Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)