UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bIDgkxTaWzuoQegD8cNNgw8Kx9VlQi9v9VGOj3mfWcE='
WHERE
key_id = '46c7c169202e1f1c2c67ca86d895dd04773fb2a9a122de9c4aa953144ea2ea4c'
AND (
token = 'bIDgkxTaWzuoQegD8cNNgw8Kx9VlQi9v9VGOj3mfWcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)