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