UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBJSFgf5H7qAv8Lh8pTqG11WjZn8UjPDHQmJh40g338='
WHERE
key_id = 'a2c4f296deb8e184d0a329e5b15b4eb938238a205536a5c7a2844717c3cf9474'
AND (
token = 'pBJSFgf5H7qAv8Lh8pTqG11WjZn8UjPDHQmJh40g338='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)