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