UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/TWXxQVf0kAIL0t2RPk3qw+JUWDs4V41/2JZ3uCAheY='
WHERE
key_id = 'ad42fd24d77ea153a41399d9d48b7ad7ed6c4e381ecb258c36574b0fffe6be9a'
AND (
token = '/TWXxQVf0kAIL0t2RPk3qw+JUWDs4V41/2JZ3uCAheY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)