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