UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sQwIw9SlVGjVq+fk9GUZqszHCpGm3ZhKzv47mpgu2x4='
WHERE
key_id = '678b120ca7c856e42d7601880a049568fc55148a2bd3984bf2388442ef50aaa3'
AND (
token = 'sQwIw9SlVGjVq+fk9GUZqszHCpGm3ZhKzv47mpgu2x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)