UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '98YJFYv5f5cTKk69BfY6urgz+aKYVFVIDjnK98aO/HA='
WHERE
key_id = 'f535375d0fcc67da2c79e7d953eb4d4382e11333b169c0ea2242a975049ca6dc'
AND (
token = '98YJFYv5f5cTKk69BfY6urgz+aKYVFVIDjnK98aO/HA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)