UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7siokAjIy/Y/gB380I2LJolDTA7YGKOjmpe8OkFqiY='
WHERE
key_id = 'fa05eb6370b4c0aa64b17bc0b09084923e023329e0d6c4eba58198b0ca72e803'
AND (
token = 'e7siokAjIy/Y/gB380I2LJolDTA7YGKOjmpe8OkFqiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)