UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oX4BzuQ4xD7B+utV12/ZuhZtqKmOFRbfXj/Zf/FHKs4='
WHERE
key_id = '524cb9794ae95e1824475a1c8be57b0da8477c4eea0d2c9aa9ff60a05cadbcf5'
AND (
token = 'oX4BzuQ4xD7B+utV12/ZuhZtqKmOFRbfXj/Zf/FHKs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)