UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ihPZ+Au7IyDfmDItvpO+SOBa7StpxAyx+k/0kqxQJM='
WHERE
key_id = '9bdb31565253838e5b662d62bbcc961d80e1853d9cf5cc0a58aba8f37acf6197'
AND (
token = '7ihPZ+Au7IyDfmDItvpO+SOBa7StpxAyx+k/0kqxQJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)