UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F6BoCRjI+Wwxcpcge2iIPLQY4V67+JU6aR4YsySOWWw='
WHERE
key_id = 'd1e4831a6b2019734236be66602a2e777de4e6ca3e9919750156b31ab077dae2'
AND (
token = 'F6BoCRjI+Wwxcpcge2iIPLQY4V67+JU6aR4YsySOWWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)