UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5TgvBYWKU+uUgrtG66nfXIj1IQunTfY/IRb+wR/alcU='
WHERE
key_id = '42c0787a91778a7d896be9328b1faa17d2b67a5c5808ca316dde76f47f2840ea'
AND (
token = '5TgvBYWKU+uUgrtG66nfXIj1IQunTfY/IRb+wR/alcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)