UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Mt6goffo5EfDyAGt+ZsrQ/40LTpaBo213jsE4FaUNeA='
WHERE
key_id = 'bc17d7bdc7fcb93cea27e9c769d0c73f868a9f1d9696eb3dc3178100fc794a8d'
AND (
token = 'Mt6goffo5EfDyAGt+ZsrQ/40LTpaBo213jsE4FaUNeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)