UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2PR8gi6IPIsk7O0rBpnjaVzdOhnn/YNfNUT4aicuGgE='
WHERE
key_id = '96923e86443fdeefc85632688350dfb29e3c4684d3ac0f53935cae9ca8b9151a'
AND (
token = '2PR8gi6IPIsk7O0rBpnjaVzdOhnn/YNfNUT4aicuGgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)