UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SpqQhQViAOAw7O+xfOs367+so9Yan7Bmrjk8CpzKEfw='
WHERE
key_id = '3114f67b5332167e7fc04bcc868eb5f222f868703bccdb48ad200e1a6b250b47'
AND (
token = 'SpqQhQViAOAw7O+xfOs367+so9Yan7Bmrjk8CpzKEfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)