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