UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Q0ATeYxwiwRvi0CpuUHMlNtIlLbM8blc52ny0it7WE='
WHERE
key_id = 'c0cf754dca8fb1fb50f5d95c7309b2f86254f818655d31d0833d0d1bdf01b916'
AND (
token = '/Q0ATeYxwiwRvi0CpuUHMlNtIlLbM8blc52ny0it7WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)