UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Vlq2sWA7BDnDLR8uEUVs7UXB0/1vZfzG6jWxsP7d8sw=' 
WHERE 
  key_id = '506ea6f792e4627516152b7c303c06a0ffe6e97da257f06df9d00ac9fef51676' 
  AND (
    token = 'Vlq2sWA7BDnDLR8uEUVs7UXB0/1vZfzG6jWxsP7d8sw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016